Microsoft Excel Level 3

Outcomes

Participants will learn how to work with advanced features of Excel 2000. Participants will learn various advanced techniques for analyzing and manipulating data in Excel.

Prerequisites

Windows (95/98/NT 4) introduction, or equivalent knowledge.
Microsoft Excel 2000 Level 1 and 2, or equivalent knowledge

What should you be familiar with?



Session Length

1 Day, 9:00am to 4:30pm

Location

This session is conducted either on site, or at our training rooms.

Topics Covered in this session

---

Customizing the work area Working with built-in toolbars Using custom toolbars Creating and using styles Using templates Advanced formula construction Using names Using the IF function Using the VLOOKUP function Using IS functions and the Auditing features Using pivot tables Creating pivot tables Modifying pivot tables Grouping and summarizing data in a pivot table Working with multiple worksheets Working with workbooks Linking cells in different workbooks Workbook versus links and workspaces

Consolidating data from more than one worksheet Using the Goal Seek and Solver utilities Using Scenario Manager to view a worksheet with different input values Using protection and display options Using comments Protecting workbooks Using custom views Introduction to macros Running macros Recording a macro Viewing and editing VBA code Working with interactive Excel Web documents Saving Excel worksheets as Web documents Spreadsheet Web Components

Performance-based objectives

• Customize toolbars and create styles and templates.
• Create decision-making functions.
• Analyze worksheet data by creating pivot tables.
• Compare and contrast workbook files and file links.
• Outline and consolidate worksheets and analyze worksheet data by using the Scenario Manager.
• Display and protect worksheet data by locking cells.
• Record and modify macros by using the Visual Basic Editor.
• Create and work with interactive Web documents.